home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The Business Master (3rd Edition)
/
The Business Master (3rd Edition).iso
/
files
/
spreotus
/
123tools
/
123key.doc
< prev
next >
Wrap
Text File
|
1983-12-11
|
4KB
|
94 lines
PROKEY SUBSET FOR 1-2-3 [123KEY.DOC]
-----------------------
In order for Prokey to work with a 123 spreadsheet, certain
setups are required. First, the 123 system disk must contain
the files PROKEY.EXE (the main PROKEY tm. program) as well as
the file 123KEY.PRO which is the file that contains all the
custom key assignments to be used while in 1-2-3.
An additional third file may be included 123KEY.BAT (may be
re-named Autoexec.bat). This file installs prokey and the keys
before it calls in the main 1-2-3 program.
[123KEY.BAT]= PROKEY/R 123KEY.PRO
123
^Z
Upon boot-up the PROKEYS for 1-2-3 will be loaded into high
memory and will be invisible to the user until called.
One additional set-up is required on each new spreadsheet that
is started. Because of the way 1-2-3 defines certain of the
function keys, it is necessary to inbed the definitions some
where in a group of isolated spreadsheet cells. In doing so
you will cause PROKEY to interact with the 1-2-3 typing alternative.
The result is to move the functions STEP NAME ABS QUERY TABLE CALC GRAPH
from their respective keys F3 F4 F7 F8 F9 F10 to their new assignments
respectively altF3 altF4 altF7 altF8 altF9 altF10.
The move is to allow the re-assignment of those function keys as follows:
F3 becomes HOME
F4 becomes END
F7 becomes the UP arrow
F8 becomes the DOWN arrow
F9 becomes the LEFT arrow
F10 becomes the RIGHT arrow
You may now leave your NumLock key on and use the keypad as a
numeric keypad. As stated above this requires a ONE-TIME-ONLY
setup on EACH NEW spreadsheet. The setup is an automatic feature
built into the Prokey set loaded by the first step. To use the
setup feature do this:
**** AFTER YOU HAVE CALLED IN A NEW SHEET OR CLEARDED THE ****
**** OLD SHEET TO BUILD A NEW ONE, PRESS altF2 . ****
AltF2 moves the cursor to Cell position BA1 and writes
cells that 1-2-3 's typing alternative will use in
re-defining the keypad. If this group of cells at
BA1 is going to interfere with the spreadsheet, you
may change their location by useing the 1-2-3 MOVE
command to move the group to another section of the sheet.
Or if you can change the prokey 123PRO.KEY file to have
another beginning cell in place of BA1 (To do this pull
up 123PRO.KEY with an editor and find BA1, change it!).
Each cell in this special group has a range name and they
remain the same in a 1-2-3 move. It is these names that
the typing alternative uses in looking for those cells.
|------|------|
| HELP |EDIT |
| | |
| alt | alt | Print this template on an
| step |setup | Epson or Epson-like printer
|------|------| in the compressed print mode.
| HOME |END |
| | | then draw the arrows in the
| alt |alt | bottom four boxes as follows:
| name |abs |
|------|------|
| | |
| GOTO |WINDOW|
| | |
|------|------|
| /|\ | | |
| | | \|/ | up down
| alt |alt |
|query |table |
|------|------| left right
| /___ | ___\ |
| \ | / |
| alt |alt | Now tape this to your 1-2-3
| calc |graph | plastic template.
|______|______|
To use this you need to own PROKEY and download three files to put on your
1-2-3 system disk. They are as follows : [123KEY.DOC]=this explanation
[123KEY.PRO]=the prokey definition file [123KEY.BAT]=the new 123 autoexec.bat